速報APP / 教育 / excel 2007 Tutor (In Eng - Hindi - Tamil

excel 2007 Tutor (In Eng - Hindi - Tamil

價格:免費

更新日期:2017-09-22

檔案大小:13M

目前版本:5.0

版本需求:Android 4.4 以上版本

官方網站:http://www.eduocean.net

Email:eduoceansoftwares@gmail.com

聯絡地址:隱私權政策

excel 2007 Tutor (In Eng - Hindi - Tamil )(圖1)-速報App

excel 2007 Tutor - In Eng - Hindi - Tamil

On screen tutor

-----------------------------------------------------------------

• Best Free tutorial (India & International)

• Basic to Intermediate training

• Hands on examples

• 4-5 hrs Very high quality Audio Video lessons ( Crystal Clear Quality )

• Step by step explanation

• Application shortcut keys

_____________________________________________

MS excel 2007 - Contents

Chapter -1

Introduction & starting of excel

Understand workbook & worksheet

Understand Rows, columns,

Understand Cells & formula bars

Data entering, Boarding,

coloring merging in cells

Number formats

excel 2007 Tutor (In Eng - Hindi - Tamil )(圖2)-速報App

Chapter-2

Filling the series

Sum in excel, auto sum

using formula bar & formula menu

Chapter-3

Copy -paste ,Cut -paste

Using Undo-redo in cells

GOTO and FIND operation

FIND and REPLACE of text

Add, Delete- row and column

Chapter-4

Format cell

Formatting a table

Hide, unhide rows and columns

Rename , add a sheet in work book

Apply background image in worksheet

Chapter-5

Inserting a chart

Formatting a chart

excel 2007 Tutor (In Eng - Hindi - Tamil )(圖3)-速報App

conditional formatting

Chapter-6

Create new workbook

Saving a workbook

Open an existing workbook

Page layout menu

Chapter-7

Protect the worksheet

Protect the workbook

Unprotect the worksheet

Unprotect the work book

Chapter-8

Shorting data

Auto Filter data

Advance filtering

Chapter -9

Inserting & editing pic in worksheet

Inserting clipart in worksheet

Inserting & editing on command in cells

excel 2007 Tutor (In Eng - Hindi - Tamil )(圖4)-速報App

hyperlink in excel

Chapter- 10

Goal seek & Scenario manager

Spelling correction in excel

Auto correction option

Formula audition

Macros in excel & with example

Chapter -11

Subtotal

Pivot table and chart

Data validation

Exercises (do it with it )

Chapter -12

How to calculate mark sheet

Chapter -13

Data entering of consumer

Chapter -14

Draw a chart - data entered of consumer

Chapter-15

excel 2007 Tutor (In Eng - Hindi - Tamil )(圖5)-速報App

Profit sharing

excel 2007 Tutor (In Eng - Hindi - Tamil )(圖6)-速報App